DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	320280
Missing cells	48827
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.2 MiB
Average record size in memory	112.0 B

Variable types

Categorical	4
DateTime	1
Numeric	9

Alerts

`VERSIE` has constant value ""	Constant
`DATUM_BESTAND` has constant value ""	Constant
`PEILDATUM` has constant value ""	Constant
`TYPERENDE_DIAGNOSE_CD` has a high cardinality: 1899 distinct values	High cardinality
`BEHANDELEND_SPECIALISME_CD` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`AANTAL_PAT_PER_ZPD` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly overall correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly overall correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly overall correlated with `BEHANDELEND_SPECIALISME_CD` and 1 other fields	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 48827 (15.2%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.19692021)	Skewed

Reproduction

Analysis started	2023-03-08 14:29:41.465602
Analysis finished	2023-03-08 14:30:01.855412
Duration	20.39 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

VERSIE
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

1.0	320280

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	960840
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	320280	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	320280	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	320280	33.3%
.	320280	33.3%
0	320280	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	640560	66.7%
Other Punctuation	320280	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	320280	50.0%
0	320280	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	320280	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	960840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	320280	33.3%
.	320280	33.3%
0	320280	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	960840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	320280	33.3%
.	320280	33.3%
0	320280	33.3%

DATUM_BESTAND
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2023-02-03	320280

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3202800
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-02-03
2nd row	2023-02-03
3rd row	2023-02-03
4th row	2023-02-03
5th row	2023-02-03

Common Values

Value	Count	Frequency (%)
2023-02-03	320280	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-02-03	320280	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	960840	30.0%
0	960840	30.0%
3	640560	20.0%
-	640560	20.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2562240	80.0%
Dash Punctuation	640560	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	960840	37.5%
0	960840	37.5%
3	640560	25.0%

Dash Punctuation

Value	Count	Frequency (%)
-	640560	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3202800	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	960840	30.0%
0	960840	30.0%
3	640560	20.0%
-	640560	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3202800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	960840	30.0%
0	960840	30.0%
3	640560	20.0%
-	640560	20.0%

PEILDATUM
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2023-02-01	320280

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3202800
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-02-01
2nd row	2023-02-01
3rd row	2023-02-01
4th row	2023-02-01
5th row	2023-02-01

Common Values

Value	Count	Frequency (%)
2023-02-01	320280	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-02-01	320280	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	960840	30.0%
0	960840	30.0%
-	640560	20.0%
3	320280	10.0%
1	320280	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2562240	80.0%
Dash Punctuation	640560	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	960840	37.5%
0	960840	37.5%
3	320280	12.5%
1	320280	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	640560	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3202800	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	960840	30.0%
0	960840	30.0%
-	640560	20.0%
3	320280	10.0%
1	320280	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3202800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	960840	30.0%
0	960840	30.0%
-	640560	20.0%
3	320280	10.0%
1	320280	10.0%

JAAR
Date

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

Minimum	2012-01-01 00:00:00
Maximum	2022-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=11)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	437.71961

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	335
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	987.35022
Coefficient of variation (CV)	2.2556682
Kurtosis	61.222425
Mean	437.71961
Median Absolute Deviation (MAD)	8
Skewness	7.9457087
Sum	1.4019284 × 10⁸
Variance	974860.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	45280	14.1%
313	41468	12.9%
303	36880	11.5%
330	25328	7.9%
316	21805	6.8%
308	17276	5.4%
306	13436	4.2%
324	13228	4.1%
301	12828	4.0%
304	10397	3.2%
Other values (18)	82354	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	12828	4.0%
302	7015	2.2%
303	36880	11.5%
304	10397	3.2%
305	45280	14.1%
306	13436	4.2%
307	5583	1.7%
308	17276	5.4%
310	3499	1.1%
313	41468	12.9%

Value	Count	Frequency (%)
8418	4260	1.3%
8416	560	0.2%
1900	210	0.1%
390	864	0.3%
389	3382	1.1%
362	4311	1.3%
361	2303	0.7%
335	3236	1.0%
330	25328	7.9%
329	834	0.3%

TYPERENDE_DIAGNOSE_CD
Categorical

Distinct	1899
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

101	1355
402	1309
403	1282
301	1282
201	1204
Other values (1894)	313848

Length

Max length	4
Median length	3
Mean length	3.352707
Min length	2

Characters and Unicode

Total characters	1073805
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	< 0.1%

Sample

1st row	12
2nd row	12
3rd row	12
4th row	12
5th row	12

Common Values

Value	Count	Frequency (%)
101	1355	0.4%
402	1309	0.4%
403	1282	0.4%
301	1282	0.4%
201	1204	0.4%
203	1197	0.4%
401	1069	0.3%
404	1060	0.3%
802	1045	0.3%
409	1035	0.3%
Other values (1889)	308442	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
101	1355	0.4%
402	1309	0.4%
403	1282	0.4%
301	1282	0.4%
201	1204	0.4%
203	1197	0.4%
401	1069	0.3%
404	1060	0.3%
802	1045	0.3%
409	1035	0.3%
Other values (1889)	308442	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	205471	19.1%
0	196833	18.3%
2	142360	13.3%
3	116293	10.8%
5	82848	7.7%
9	77363	7.2%
4	76135	7.1%
7	63249	5.9%
6	56160	5.2%
8	46242	4.3%
Other values (15)	10851	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1062954	99.0%
Uppercase Letter	10851	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2022	18.6%
M	1835	16.9%
B	1302	12.0%
E	913	8.4%
Z	906	8.3%
D	728	6.7%
A	705	6.5%
F	676	6.2%
C	359	3.3%
K	350	3.2%
Other values (5)	1055	9.7%

Decimal Number

Value	Count	Frequency (%)
1	205471	19.3%
0	196833	18.5%
2	142360	13.4%
3	116293	10.9%
5	82848	7.8%
9	77363	7.3%
4	76135	7.2%
7	63249	6.0%
6	56160	5.3%
8	46242	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1062954	99.0%
Latin	10851	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2022	18.6%
M	1835	16.9%
B	1302	12.0%
E	913	8.4%
Z	906	8.3%
D	728	6.7%
A	705	6.5%
F	676	6.2%
C	359	3.3%
K	350	3.2%
Other values (5)	1055	9.7%

Common

Value	Count	Frequency (%)
1	205471	19.3%
0	196833	18.5%
2	142360	13.4%
3	116293	10.9%
5	82848	7.8%
9	77363	7.3%
4	76135	7.2%
7	63249	6.0%
6	56160	5.3%
8	46242	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1073805	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	205471	19.1%
0	196833	18.3%
2	142360	13.3%
3	116293	10.8%
5	82848	7.7%
9	77363	7.2%
4	76135	7.1%
7	63249	5.9%
6	56160	5.2%
8	46242	4.3%
Other values (15)	10851	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6017
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4209996 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999040
Q1	99899010
median	1.49899 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051604 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9010499 × 10⁸

Descriptive statistics

Standard deviation	4.2928588 × 10⁸
Coefficient of variation (CV)	0.97101543
Kurtosis	-1.7434152
Mean	4.4209996 × 10⁸
Median Absolute Deviation (MAD)	1.1999999 × 10⁸
Skewness	0.46129299
Sum	1.4159578 × 10¹⁴
Variance	1.8428637 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2322	0.7%
990004007	2290	0.7%
990003004	2242	0.7%
990004006	1868	0.6%
990356076	1691	0.5%
990356073	1566	0.5%
131999228	1489	0.5%
131999164	1475	0.5%
990003007	1464	0.5%
131999194	1352	0.4%
Other values (6007)	302521	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	11	< 0.1%
10501004	11	< 0.1%
10501005	11	< 0.1%
10501007	3	< 0.1%
10501008	11	< 0.1%
10501010	11	< 0.1%
10501011	3	< 0.1%
11101002	10	< 0.1%
11101003	11	< 0.1%

Value	Count	Frequency (%)
998418081	162	0.1%
998418080	145	< 0.1%
998418079	38	< 0.1%
998418077	8	< 0.1%
998418076	8	< 0.1%
998418075	7	< 0.1%
998418074	214	0.1%
998418073	215	0.1%
998418072	8	< 0.1%
998418071	8	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct	10093
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	518.9254

Minimum	1
Maximum	165142
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	105
95-th percentile	1770
Maximum	165142
Range	165141
Interquartile range (IQR)	102

Descriptive statistics

Standard deviation	3188.4385
Coefficient of variation (CV)	6.1443099
Kurtosis	400.19208
Mean	518.9254
Median Absolute Deviation (MAD)	13
Skewness	16.565025
Sum	1.6620143 × 10⁸
Variance	10166140
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	52650	16.4%
2	25785	8.1%
3	16807	5.2%
4	12355	3.9%
5	9709	3.0%
6	8159	2.5%
7	6784	2.1%
8	5744	1.8%
9	5214	1.6%
10	4686	1.5%
Other values (10083)	172387	53.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	52650	16.4%
2	25785	8.1%
3	16807	5.2%
4	12355	3.9%
5	9709	3.0%
6	8159	2.5%
7	6784	2.1%
8	5744	1.8%
9	5214	1.6%
10	4686	1.5%

Value	Count	Frequency (%)
165142	1	< 0.1%
158820	1	< 0.1%
155884	1	< 0.1%
154271	1	< 0.1%
154269	1	< 0.1%
144724	1	< 0.1%
118397	1	< 0.1%
115938	1	< 0.1%
111296	1	< 0.1%
110520	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	10857
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	613.09747

Minimum	1
Maximum	239960
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	15
Q3	115
95-th percentile	2014
Maximum	239960
Range	239959
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	4101.7374
Coefficient of variation (CV)	6.6901881
Kurtosis	715.7713
Mean	613.09747
Median Absolute Deviation (MAD)	14
Skewness	21.19692
Sum	1.9636286 × 10⁸
Variance	16824250
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	50678	15.8%
2	25350	7.9%
3	16633	5.2%
4	12141	3.8%
5	9634	3.0%
6	8124	2.5%
7	6788	2.1%
8	5688	1.8%
9	5147	1.6%
10	4680	1.5%
Other values (10847)	175417	54.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	50678	15.8%
2	25350	7.9%
3	16633	5.2%
4	12141	3.8%
5	9634	3.0%
6	8124	2.5%
7	6788	2.1%
8	5688	1.8%
9	5147	1.6%
10	4680	1.5%

Value	Count	Frequency (%)
239960	1	< 0.1%
232423	1	< 0.1%
231954	1	< 0.1%
231005	1	< 0.1%
227936	1	< 0.1%
227409	1	< 0.1%
226122	1	< 0.1%
223939	1	< 0.1%
218437	1	< 0.1%
215070	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct	9048
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7781.1058

Minimum	1
Maximum	227968
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	42.95
Q1	415
median	1755
Q3	6516
95-th percentile	37096
Maximum	227968
Range	227967
Interquartile range (IQR)	6101

Descriptive statistics

Standard deviation	17930.175
Coefficient of variation (CV)	2.3043222
Kurtosis	33.81119
Mean	7781.1058
Median Absolute Deviation (MAD)	1594
Skewness	5.0340866
Sum	2.4921326 × 10⁹
Variance	3.2149117 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	505	0.2%
25	479	0.1%
12	469	0.1%
8	453	0.1%
19	451	0.1%
14	442	0.1%
9	442	0.1%
17	435	0.1%
15	428	0.1%
26	424	0.1%
Other values (9038)	315752	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	350	0.1%
2	392	0.1%
3	368	0.1%
4	416	0.1%
5	376	0.1%
6	380	0.1%
7	385	0.1%
8	453	0.1%
9	442	0.1%
10	371	0.1%

Value	Count	Frequency (%)
227968	23	< 0.1%
226768	23	< 0.1%
217958	24	< 0.1%
214514	17	< 0.1%
213536	25	< 0.1%
211593	17	< 0.1%
210433	19	< 0.1%
205348	17	< 0.1%
200603	16	< 0.1%
198527	20	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

Distinct	10080
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11211.894

Minimum	1
Maximum	369838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	54
Q1	553
median	2432
Q3	9252
95-th percentile	52576
Maximum	369838
Range	369837
Interquartile range (IQR)	8699

Descriptive statistics

Standard deviation	26731.992
Coefficient of variation (CV)	2.384253
Kurtosis	37.468068
Mean	11211.894
Median Absolute Deviation (MAD)	2229
Skewness	5.285701
Sum	3.5909454 × 10⁹
Variance	7.145994 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	385	0.1%
24	368	0.1%
25	357	0.1%
38	353	0.1%
62	351	0.1%
11	349	0.1%
34	346	0.1%
32	342	0.1%
15	340	0.1%
6	339	0.1%
Other values (10070)	316750	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	270	0.1%
2	298	0.1%
3	302	0.1%
4	307	0.1%
5	325	0.1%
6	339	0.1%
7	304	0.1%
8	304	0.1%
9	258	0.1%
10	302	0.1%

Value	Count	Frequency (%)
369838	23	< 0.1%
356486	23	< 0.1%
348523	25	< 0.1%
343318	24	< 0.1%
341692	19	< 0.1%
323791	20	< 0.1%
315783	17	< 0.1%
310778	17	< 0.1%
298646	17	< 0.1%
289045	16	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct	297
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	678394.5

Minimum	1610
Maximum	1487638
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1610
5-th percentile	43722
Q1	300112
median	757886
Q3	1026523
95-th percentile	1340791
Maximum	1487638
Range	1486028
Interquartile range (IQR)	726411

Descriptive statistics

Standard deviation	409661.35
Coefficient of variation (CV)	0.60386891
Kurtosis	-1.0784094
Mean	678394.5
Median Absolute Deviation (MAD)	311287
Skewness	-0.021183526
Sum	2.1727619 × 10¹¹
Variance	1.6782242 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880940	5102	1.6%
874114	4354	1.4%
843981	4347	1.4%
894326	4333	1.4%
880492	4273	1.3%
897718	4212	1.3%
764930	4089	1.3%
794553	4016	1.3%
1081202	3890	1.2%
1100282	3866	1.2%
Other values (287)	277798	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1610	130	< 0.1%
1828	138	< 0.1%
1920	131	< 0.1%
2234	139	< 0.1%
2409	185	0.1%
2495	173	0.1%
6806	380	0.1%
11842	74	< 0.1%
17085	410	0.1%
18328	454	0.1%

Value	Count	Frequency (%)
1487638	2975	0.9%
1450405	3048	1.0%
1421741	3564	1.1%
1344482	3543	1.1%
1340791	3441	1.1%
1332424	3545	1.1%
1316613	3463	1.1%
1282954	3576	1.1%
1265246	1177	0.4%
1262541	1201	0.4%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct	297
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1094400.6

Minimum	1861
Maximum	2665627
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1861
5-th percentile	47348
Q1	496620
median	1088002
Q3	1728105
95-th percentile	2549464
Maximum	2665627
Range	2663766
Interquartile range (IQR)	1231485

Descriptive statistics

Standard deviation	734398.49
Coefficient of variation (CV)	0.6710509
Kurtosis	-0.76547154
Mean	1094400.6
Median Absolute Deviation (MAD)	630818
Skewness	0.35261249
Sum	3.5051462 × 10¹¹
Variance	5.3934114 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211793	5102	1.6%
1281514	4354	1.4%
1216262	4347	1.4%
1315592	4333	1.4%
1300459	4273	1.3%
1341876	4212	1.3%
1155560	4089	1.3%
1188880	4016	1.3%
2549464	3890	1.2%
2665627	3866	1.2%
Other values (287)	277798	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1861	130	< 0.1%
2096	138	< 0.1%
2195	131	< 0.1%
2611	139	< 0.1%
2816	173	0.1%
3167	185	0.1%
7385	380	0.1%
12718	74	< 0.1%
20651	410	0.1%
23148	500	0.2%

Value	Count	Frequency (%)
2665627	3866	1.2%
2620554	3790	1.2%
2620222	3788	1.2%
2594837	3844	1.2%
2549464	3890	1.2%
2481210	3851	1.2%
2179430	3757	1.2%
2062811	3811	1.2%
2052304	1168	0.4%
1990241	1167	0.4%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

Distinct	3524
Distinct (%)	1.3%
Missing	48827
Missing (%)	15.2%
Infinite	0
Infinite (%)	0.0%
Mean	3575.003

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	480
median	1255
Q3	4175
95-th percentile	13455
Maximum	287220
Range	287150
Interquartile range (IQR)	3695

Descriptive statistics

Standard deviation	6513.1094
Coefficient of variation (CV)	1.8218472
Kurtosis	147.66205
Mean	3575.003
Median Absolute Deviation (MAD)	1025
Skewness	7.2237192
Sum	9.704453 × 10⁸
Variance	42420593
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2003	0.6%
105	1933	0.6%
110	1791	0.6%
185	1565	0.5%
180	1498	0.5%
300	1418	0.4%
145	1385	0.4%
175	1380	0.4%
120	1335	0.4%
165	1271	0.4%
Other values (3514)	255874	79.9%
(Missing)	48827	15.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	363	0.1%
85	918	0.3%
90	689	0.2%
95	695	0.2%
100	924	0.3%
105	1933	0.6%
110	1791	0.6%
115	1024	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116805	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
96890	5	< 0.1%

Auto

Heatmap
Table

	BEHANDELEND_SPECIALISME_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
BEHANDELEND_SPECIALISME_CD	1.000	0.218	0.008	0.013	-0.060	-0.054	-0.556	-0.474	0.050
ZORGPRODUCT_CD	0.218	1.000	-0.142	-0.150	-0.180	-0.212	-0.383	-0.411	0.026
AANTAL_PAT_PER_ZPD	0.008	-0.142	1.000	0.996	0.323	0.321	0.070	0.080	-0.303
AANTAL_SUBTRAJECT_PER_ZPD	0.013	-0.150	0.996	1.000	0.319	0.321	0.073	0.087	-0.306
AANTAL_PAT_PER_DIAG	-0.060	-0.180	0.323	0.319	1.000	0.988	0.315	0.295	0.024
AANTAL_SUBTRAJECT_PER_DIAG	-0.054	-0.212	0.321	0.321	0.988	1.000	0.329	0.326	0.033
AANTAL_PAT_PER_SPC	-0.556	-0.383	0.070	0.073	0.315	0.329	1.000	0.960	-0.015
AANTAL_SUBTRAJECT_PER_SPC	-0.474	-0.411	0.080	0.087	0.295	0.326	0.960	1.000	-0.017
GEMIDDELDE_VERKOOPPRIJS	0.050	0.026	-0.303	-0.306	0.024	0.033	-0.015	-0.017	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900006	17	17	17753	22861	79304	103932	NaN
1	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900011	1253	1286	17753	22861	79304	103932	170.0
2	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900004	5	5	17753	22861	79304	103932	NaN
3	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900016	10337	11747	17753	22861	79304	103932	1150.0
4	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900014	3094	3109	17753	22861	79304	103932	2085.0
5	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900018	3649	4042	17753	22861	79304	103932	440.0
6	1.0	2023-02-03	2023-02-01	2019-01-01	1900	12	991900008	2581	2655	17753	22861	79304	103932	460.0
7	1.0	2023-02-03	2023-02-01	2019-01-01	1900	13	991900022	2	4	721	730	79304	103932	825.0
8	1.0	2023-02-03	2023-02-01	2019-01-01	1900	13	991900003	699	702	721	730	79304	103932	475.0
9	1.0	2023-02-03	2023-02-01	2019-01-01	1900	13	991900026	2	3	721	730	79304	103932	115.0

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
320270	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356060	2	2	46	56	340318	446222	4780.0
320271	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356074	1	1	46	56	340318	446222	585.0
320272	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	179799007	1	1	46	56	340318	446222	680.0
320273	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356076	36	37	46	56	340318	446222	200.0
320274	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356062	1	1	46	56	340318	446222	2005.0
320275	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356059	2	2	46	56	340318	446222	2455.0
320276	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356048	2	2	46	56	340318	446222	11225.0
320277	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356073	2	2	46	56	340318	446222	535.0
320278	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	990356056	1	1	46	56	340318	446222	7090.0
320279	1.0	2023-02-03	2023-02-01	2022-01-01	306	104	179799015	5	7	46	56	340318	446222	150.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample